create  view vMeetDonationSumm as
    select max(Trans.ST_ID) as ST_ID,
           -sum(Trans.AMOUNT) as AMOUNT
    from Trans
    where Trans.SOURCE_SYSTEM = 'MEETING'
     and  Trans.JOURNAL_TYPE = 'IN'  and  Trans.TRANSACTION_TYPE = 'DIST'
     and  Trans.IS_FR_ITEM = 1
  group by Trans.ST_ID

GO
GRANT REFERENCES ON  [dbo].[vMeetDonationSumm] TO [IMIS]
GRANT SELECT ON  [dbo].[vMeetDonationSumm] TO [IMIS]
GRANT INSERT ON  [dbo].[vMeetDonationSumm] TO [IMIS]
GRANT DELETE ON  [dbo].[vMeetDonationSumm] TO [IMIS]
GRANT UPDATE ON  [dbo].[vMeetDonationSumm] TO [IMIS]
GO